CREATE TABLE "iws_ware_nest"
(
    "material_category" VARCHAR(50) NULL DEFAULT NULL,
    "material_code"     VARCHAR(50) NULL DEFAULT NULL,
    "material_name"     VARCHAR(50) NULL DEFAULT NULL,
    "item_bar_code"     VARCHAR(50) PRIMARY KEY,
    "container_code"    VARCHAR(50) NULL DEFAULT NULL,
    "store_id"          VARCHAR(50) NULL DEFAULT NULL,
    "batch_code"        VARCHAR(50) NULL DEFAULT NULL,
    "material_status"   VARCHAR(50) NULL DEFAULT NULL,
    "entry_time"        DATETIME    NULL DEFAULT NULL,
    "ware_age"          VARCHAR(50) NULL DEFAULT NULL,
    "period_validity"   VARCHAR(50) NULL DEFAULT NULL,
    "overdue"        VARCHAR(50) NULL DEFAULT NULL,
    "freeze"         VARCHAR(50) NULL DEFAULT NULL,
    "freeze_reason"     VARCHAR(50) NULL DEFAULT NULL,
    "freeze_date"       DATETIME    NULL DEFAULT NULL,
    "manufacturers"     VARCHAR(50) NULL DEFAULT NULL,
    "purchase_code"     VARCHAR(50) NULL DEFAULT NULL,

);
exec sp_addextendedproperty 'MS_Description', N'原料、辅料、半成品', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'material_category'
go
exec sp_addextendedproperty 'MS_Description', N'物料的编号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'material_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料的名称', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'material_name'
go
exec sp_addextendedproperty 'MS_Description', N'物料的唯一标识', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'item_bar_code'
go
exec sp_addextendedproperty 'MS_Description', N'用于标识载具的唯一编码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'container_code'
go
exec sp_addextendedproperty 'MS_Description', N'储位编码', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'store_id'
go
exec sp_addextendedproperty 'MS_Description', N'物料的批次号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'batch_code'
go
exec sp_addextendedproperty 'MS_Description', N'物料状态', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'material_status'
go
exec sp_addextendedproperty 'MS_Description', N'入厂时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'entry_time'
go
exec sp_addextendedproperty 'MS_Description', N'库存年龄', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'ware_age'
go
exec sp_addextendedproperty 'MS_Description', N'有效期', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'period_validity'
go
exec sp_addextendedproperty 'MS_Description', N'是否超期', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'overdue'
go
exec sp_addextendedproperty 'MS_Description', N'是否冻结', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'freeze'
go
exec sp_addextendedproperty 'MS_Description', N'冻结原因', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'freeze_reason'
go
exec sp_addextendedproperty 'MS_Description', N'冻结时间', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'freeze_date'
go
exec sp_addextendedproperty 'MS_Description', N'供应商', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'manufacturers'
go
exec sp_addextendedproperty 'MS_Description', N'采购单号', 'SCHEMA', 'dbo',
     'TABLE', 'iws_ware_nest', 'COLUMN', 'purchase_code'
go
